/*
 * Copyright (c) 2018-2999 广州亚米信息科技有限公司 All rights reserved.
 *
 * https://www.gz-yami.com/
 *
 * 未经允许，不可做商业用途！
 *
 * 版权所有，侵权必究！
 */

package com.yami.shop.dao;

import com.yami.shop.bean.model.LoginHist;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Date;

public interface LoginHistMapper extends BaseMapper<LoginHist> {
    @Select("SELECT count(*) from (select distinct user_code from tz_login_hist  where login_time between #{begin} and #{end}) as a")
    int countByAccount(@Param("begin")Date begin,@Param("end") Date end);
}